2015-04-21 - 17194 - Spec- New VAS Condition table and update in the VAS program (Dan by 2015-05-01) #OrderEntry #ABAP

SPECIFICATIONS

17194.100 -Spec- Dual-Currency UPC


Purpose

Need to create a new VAS condition table and update it in UPC label program for material and Purchase order inputs.Add the new table in ZRSD_VAS_UPDATE program.

Admin Info

Purpose
 Need to create a new VAS condition table and update it in UPC label program for material and Purchase order inputs.Add the new table in ZRSD_VAS_UPDATE program.
Requested By
 Daniel Brennan
Spec Created By
 Deepak Yasam
Spec Created Date
 04/23/2015
Spec QA by
 Deepak Yasam
Objects
 ZRSD_UPC_LABELS
ZRSD_VAS_UPDATE
Document Status
 WIP


Estimates


Sl.No
 Activity
 Estimation in Hours
1
 Research
 00
2
 Documentation
 04
3
 Development/ Config
 16
4
 Unit test in DEV
 06
5
 Unit test in QUA
 00
6
 Other activity

TOTAL
 26

References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]

None

Documents

[Attach any document(s) received for the requirement(s)]

None


Spec Changes

[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]

Sl.
 Change Details
 Requested By
 Requested On
 Notes if any

























Functional Requirement

Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]
New VAS table is required and the labels should get printed based on the VAS codes mainatined in it.

In Scope:

[List the activities to be included in scope]
The new VAS condition table logic is added for material and purchase order inputs in the UPC label programs.

Out of Scope:

[Out of scope activities]
Other inputs doesn't read the VAS codes from the new table.

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]

1.A new Condition table should be created and assigned to the ZAST access sequence of VAST condition table as below.

“Sales Org / Distr. Chl / Division / Plant”

2.The program ZRSD_VAS_UPDATE should be updated to include the new VAS condition table to fill the entries into ZSDVAS table.

3.The UPC label program should be updated with the new VAS condition table to read the VAS codes for the material and Purchase order inputs.


Test Plan

[List test scenarios/cases to be executed here]
Test ID
 Scenario
 Expected Result
SD-001
 For Stock items:

Execute ZSD_UPCLBL t.code
with the below inputs.

Material,size,qty,S.org,cur,MSRP
 The condition record should be fetched from the below tables in a series.

KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr
KOTK906 Sales org./Distr. Chl/Division/Customer
KOTK907 Sales org./Distr.
Chl/Division/VAS Cu.Gr/Material
KOTK908 Sales org./Distr. Chl/Division/Customer/Material
KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr
KOTK909 Sales org./Distr. Chl/Division/Customer/Usage
KOTK902 Sales org./PO type
KOTK922 Sales org./Distr. Chl/Division/Plant


The condition record from 922 table should be used to print the labels as no other condition record is maintained ie., L98,S11 with delivering plant 0610 in the MM.
SD-002
 For Stock items:

Execute ZSD_UPCLBL t.code with the below inputs.

Material,size,qty,S.org,cur,MSRP
 The condition record should be fetched from the below tables in series.

KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr
KOTK906 Sales org./Distr. Chl/Division/Customer
KOTK907 Sales org./Distr. Chl/Division/VAS Cu.Gr/Material
KOTK908 Sales org./Distr. Chl/Division/Customer/Material
KOTK903 Sales org./Distr. Chl/Division/Customer/Usage/VAS Mat.gr
KOTK909 Sales org./Distr. Chl/Division/Customer/Usage
KOTK902 Sales org./PO type
KOTK922 Sales org./Distr. Chl/Division/Plant


As no condition record is maintained/deleted in any of the above tables and the condition record in KOTK922 with plant 0610(delivering plant in the MM) is deleted, no label should get printed.
SD-003
 For Stock Items:

Below are the inputs for prepack materials :

Execute ZSD_UPCLBL transaction with the inputs Material number,size,qty,sales org,currency,MSRP with print components button flagged
 Only the input material, size,quantity and their respective components should get printed.

As no condition records are maintained/deleted in the series of tables, the VAS codes ie.,L12 ,S20 from KOTK922 table with 0320 plant(delivering plant in MM) are used to print the labels.
SD-004
 For Stock Items:

Below are the inputs for prepack materials :

Material number,size,qty,sales org,currency,MSRP with print components button unflagged
 The input material, size,quantity should get printed .

As no condition records are maintained/deleted in the series of tables, the VAS codes ie.,L12 ,S20 from KOTK922 table with 0320 plant(delivering plant in MM) are used to print the labels.
SD-005
 For Stock Items:

Below are the inputs for prepack materials :

Material number,size,qty,sales org,currency,MSRP with print components button flagged
 As no condition record is maintained/deleted in any of the above series tables and the condition record in KOTK922 with plant 0315 (delivering plant in the MM) is deleted, no label should get printed.
SD-006
 For Stock Items:

Below are the inputs for prepack materials :

Material number,size,qty,sales org,currency,MSRP with print components button unflagged
 As no condition record is maintained/deleted in any of the above series tables and the condition record in KOTK922 with plant 0315 (delivering plant in the MM) is deleted, no label should get printed..
SD-007
 For Stock items:

Create a Purchase order and execute in ZSD_UPCLBL T.code under UPC(stock items only)
 The condition record should be fetched from below tables ie.,

KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr
KOTK922 Sales org./Distr. Chl/Division/Plant

The valid condition record is found in KOTK922 table with plant 0610 and 3200 sales org. Both item 10 and 20 are printed as they have record with 0610 plant in the PO.
SD-008
 For Stock items:

Create a Purchase order and execute in ZSD_UPCLBL T.code under UPC(stock items only)
 The condition record should be fetched from below tables ie.,

KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr
KOTK922 Sales org./Distr. Chl/Division/Plant

The valid condition record is found in KOTK922 table with plant 0610 and 3200 sales org and item 10 is printed.

Item 20 is not printed as the condition record with plant 0620 and sales org 3200 is deleted in KOTK922 table.
SD-009
 For Stock items:

Create a Purchase order and execute in ZSD_UPCLBL T.code under UPC(stock items only)
 The condition record should be fetched from below tables ie.,

KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr
KOTK922 Sales org./Distr. Chl/Division/Plant

The valid condition record is found in KOTK922 table with plant 0610 and 3200 sales org. Only item 20 is printed as item 20 is deleted in the PO.
SD-010
 For Stock items:

Create a Purchase order with some deleted pre pack materials and execute in ZSD_UPCLBL T.code under UPC(stock items only) with print components flagged.
 The condition record should be fetched from 901 table ie.,

KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr
KOTK922 Sales org./Distr. Chl/Division/Plant

Valid condition record is found in KOTK922 table with plant 0320 and sales org 2000.

Only the undeleted material sizes and their respective components should get printed in the output
SD-011
 For Stock items:

Create a Purchase order with some deleted pre pack materials and execute in ZSD_UPCLBL T.code under UPC(stock items only) with print components unflagged
 The condition record should be fetched from 901 table ie.,

KOTK901 Sales org./Distr. Chl/Division/Customer/VAS Mat.gr
KOTK922 Sales org./Distr. Chl/Division/Plant

Valid condition record is found in KOTK922 table with plant 0320 and sales org 2000.

Only the undeleted main material sizes of the purchase order should get printed.


Solution Details

[Provide complete technical details for configuration or programming here]

1.A new VAS condition table KOTK922 is created with the below inputs and assigned to ZAST access seq of VAST condition type.
“Sales Org / Distr. Chl / Division / Plant”

Issues

[List Issues / Bugs identified in configuration or development]